home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / oracl / mar97 / koopf101.gif < prev    next >
Graphics Interchange Format  |  1997-06-27  |  31KB  |  631x169  |  4-bit (16 colors)
Labels: text | screenshot | diagram
OCR: FIGURE 1: Good clustering vs. poor clustering. Good clustering can reduce CPU time, elapsed times, disk I/O, and wasted space, because the order of the rows in the table follows the order of the index entries in the leaf blocks. Poor clustering makes retrieving data for a given key disorganized, and the associated rows for that key in the table may be scattered across many noncontiguous blocks. Good Clustering Poor Clustering Root Block (index) B-level Branch Block[s] [index) Leof Blocks (index) Data Blocks [table)